Tables [dbo].[EventSetupLabel]
Properties
PropertyValue
Created10:31:20 AM Tuesday, March 02, 2010
Last Modified11:40:02 AM Monday, February 20, 2012
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_EventSetupLabel: EventCodeForeign Keys FK_EventSetupLabel_EventSetupGeneral: [dbo].[EventSetupGeneral].EventCodeEventCodevarchar(15)15
No
StartRegistrationLabelvarchar(64)64
No
RegistrantLabelvarchar(64)64
No
FunctionsLabelvarchar(64)64
No
GuestLabelvarchar(64)64
No
QuestionLabelvarchar(64)64
No
SummaryLabelvarchar(64)64
No
QuestionPageMessagevarchar(256)256
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_EventSetupLabel: EventCodePK_EventSetupLabelEventCode
Yes
Foreign Keys Foreign Keys
NameColumns
FK_EventSetupLabel_EventSetupGeneralEventCode->[dbo].[EventSetupGeneral].[EventCode]
SQL Script
CREATE TABLE [dbo].[EventSetupLabel]
(
[EventCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[StartRegistrationLabel] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[RegistrantLabel] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FunctionsLabel] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[GuestLabel] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[QuestionLabel] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SummaryLabel] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[QuestionPageMessage] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[EventSetupLabel] ADD CONSTRAINT [PK_EventSetupLabel] PRIMARY KEY CLUSTERED ([EventCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[EventSetupLabel] ADD CONSTRAINT [FK_EventSetupLabel_EventSetupGeneral] FOREIGN KEY ([EventCode]) REFERENCES [dbo].[EventSetupGeneral] ([EventCode])
GO
Uses
Used By